package cn.tedu.user.management.dao.persist.mapper;

import cn.tedu.user.management.pojo.entity.SectionJob;
import cn.tedu.user.management.pojo.vo.JobEnableListItemVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
* @author 86188
* @description 针对表【section_job(部门职位关联)】的数据库操作Mapper
* @createDate 2023-06-17 09:42:05
* @Entity cn.tedu.user.management.pojo.entity.SectionJob
*/
public interface SectionJobMapper extends BaseMapper<SectionJob> {

    /*
    * 查询招聘职位列表
    */
    List<JobEnableListItemVO> enableList(Long sectionId);

    /*
     * 根据id查job_id
     */
    Long selectJobIdById(Long id);

    /*
     * 根据SectionId和JobId和jobId获取sectionJobId
     */
    Long selectId(Long sectionId, Long jobId);
}




